﻿CREATE TABLE [dbo].[NetManagerInfo] (
    [ID]           INT              IDENTITY (1, 1) NOT NULL,
    [DepartmentID] INT              NOT NULL,
    [LoginName]    NVARCHAR (20)    NOT NULL,
    [Password]     NVARCHAR (32)    NOT NULL,
    [Code]         NVARCHAR (20)    NULL,
    [RealName]     NVARCHAR (10)    NULL,
    [Sex]          BIT              NULL,
    [Eamil]        VARCHAR (50)     NULL,
    [Tel]          VARCHAR (15)     NULL,
    [Address]      NVARCHAR (2000)  NULL,
    [AddDate]      DATETIME         NULL,
    [Logins]       INT              NULL,
    [FirstLogin]   DATETIME         NULL,
    [LastLogin]    DATETIME         NULL,
    [LoginIP]      VARCHAR (15)     NULL,
    [IfLock]       BIT              NULL,
    [IfDelete]     BIT              NULL,
    [CertNumber]   UNIQUEIDENTIFIER NOT NULL,
    [TenantID]     UNIQUEIDENTIFIER NULL,
    CONSTRAINT [PK_ManagerInfo] PRIMARY KEY CLUSTERED ([ID] ASC)
);




GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'管理员信息表', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'ID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'部门标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'DepartmentID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'登陆名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'LoginName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'登陆密码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Password';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户编码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Code';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'真实姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'RealName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户性别', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Sex';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户邮箱', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Eamil';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户电话', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Tel';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'联系地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Address';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'添加日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'AddDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'登陆次数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'Logins';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'首次登陆', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'FirstLogin';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'末次登陆', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'LastLogin';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'登陆IP', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'LoginIP';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否锁定', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'IfLock';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否删除', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetManagerInfo', @level2type = N'COLUMN', @level2name = N'IfDelete';

